Previous Topic

Next Topic

Concepts and Terms: Intelligent Query Architect

Alias

An alternate name for a column (property).

For example, you could define Postal Code as the alias for the Zip column name.

Business Object

A collection of self-contained data that represents an entity or process, and shields the physical data.

For example, the CsContact business object can represent a view of a person or organization and the processes that a person or organization can perform.

Comparison Method

Specifies the method by which data is restricted for a column.

For example, to return orders for more than $1000.00, create a filter set that uses the "Greater" Comparison operator and enter "1000" in the Value field.

CORE

Central Object Repository. A server-side file system containing documents and objects (business objects, query objects, and output processes).

Example of CORE with content folders

Display Order

Refers to the columns that display in the results for a query.

Note: The default column sort order is derived from the first query source. You can override the sort order, if necessary.

Example of a query definition showing display order

Filter

One or more column-specific search conditions.

For example, if you wanted all contacts who live in Texas (CsContact.STATE_PROVINCE = "TX") or who subscribe to a journal (Subscriptions.PRODUCT_CODE = "JOUR"), you could define a filter set using the Or connector, so that only those contacts either from Texas or who subscribe to a journal return.

Example of a filter set

Function

Summarizes some characteristic of the current set of rows. The functions that are available depends on the data type of the column you selected.

Note: You must select only one column when using a function. For example, if you want the maximum ID, ID must be the only column listed on the Display tab.

Avg

Returns the average of the values in the specified column.
(Numeric data type only)

Count

Returns the number of rows that are in the table or that meet certain conditions.
(Any data type)

Max

Returns the maximum value found in the specified column.
(Character and numeric data types)

Min

Returns the minimum value found in the specified column.
(Character and numeric data types)

Sum

Returns the sum of all values found in the specified column.
(Numeric data type only)

IQA

Intelligent Query Architect. The query-building tool used to extract data from the iMIS database.

Join Operator

The logic that combines data from multiple tables into a single result table. The following join operators are available in IQA:

Object

Self-contained element that consists of instructions to manipulate data; for example, a business object or query object.

Parameterized Query

A query that requires a value from the user at runtime.

For example, a query to obtain the registrants for a closed event may prompt the user at runtime to supply the event code of the closed event.

Example of a filter definition for a parameterized query

Example of a prompt that displays when a parameterized query is run

Priority

Refers to the order in which the data for a particular column is sorted.

Example of a query definition showing a specified sort order

Query

User-defined criteria used to retrieve a subset of data.

Relation

The part of a query definition that specifies a relationship between two or more sources and is used to restrict the data the query returns.

For example, if you wanted to define a query that returns members with orders over the amount of $1,000, you could create a relationship where the CsContact.Id = CsOrders.BillToId.

Note: You can use the default relation, if one exists, or you can define a specific relation.

Example of a query definition showing a default relation

Schema

Refers to the structure of a database.

Source

Object that is available for building query definitions. Sources include both business objects and query objects. Query definitions can be created based on one or more sources.

See Also

Understanding Intelligent Query Architect

Key Features: Intelligent Query Architect

Task Map: Intelligent Query Architect

Understanding iMIS queries

Tour: Intelligent Query Architect


ASI logo 10.6 Production Release. Updated 7/27/2006 3:52:52 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.